Seward County Community College/Area Technical School
Course Syllabus

1. TITLE OF COURSE: CS2313 - Microcomputer Database Management
2. COURSE DESCRIPTION: 3 Credit Hour Lecture Course This course is designed to acquaint the student with a software system for managing the storage and collection of data used and produced by a microcomputer. For each unit of credit, a minimum of three hours per week with one of the hours for class and two hours for studying/preparation outside of class is expected.
3. PROGRAM AND/OR DEPARTMENT MISSION STATEMENT: The CIS Program will provide superior learning opportunities in the area of information technology, utilizing state-of-the-art technology, for both CIS majors and non CIS majors to enable all students to achieve their career and/or educational goals.
4. TEXTBOOK AND MATERIALS:
   • Microsoft Access 2013, Complete, Illustrated Series.  Lisa Friedrichsen, Cengage Learning, 2014.
5. SCCC/ATS OUTCOMES: Students who successfully complete this course will demonstrate the ability to do the following SCCC/ATS Outcomes:
   • Outcome #1 – Read with comprehension, be critical of what they read, and apply knowledge gained to real life situations
   • Outcome # 5 – Demonstrate the ability to think critically by gathering facts, generating insights, analyzing data, and evaluating information
   • Outcome # 6 - Utilize current technology relevant to their respective disciplines
   • Outcome #9 – Exhibit workplace skills that include respect for others, teamwork competence, attendance/punctuality, decision making, conflict resolution, truthfulness/honesty, positive attitude, judgment, and responsibility
6. COURSE OUTCOMES: Upon completion of the Microcomputer Database Management course with 80% or higher mastery the student should be able to:
   • Perform basic database management activities using database software
   • Utilize advanced functions of database management software for creation of forms, tables, queries and reports
7. COURSE OUTLINE:
   • Getting Started with Access 2013
   • Using Tables and Queries
   • Using Forms
   • Using Reports
   • Modifying a Database Structure
   • Creating Multiple Table Queries
   • Developing Forms and Subforms
   • Sharing Information and Improving Reports
   • Sharing Access Information with Other Office Programs
   • Creating Data Access Pages
   • Creating Advanced Queries
   • Creating Advanced Forms and Reports
   • Managing Database Objects
   • Creating Macros
   • Creating Modules
   • Managing the Database
8. INSTRUCTIONAL METHODS:
   • Classroom Lecture
   • Classroom Discussion
   • Hands-on computer lab projects and database assignments
   • Instructors will enforce the Academic Honor Code & Cheating Policy as set forth in the SCCC College Catalog. Students who fail to adhere to this policy will receive an F for the course final grade unless otherwise stated in the instructors's course policies.
9. INSTRUCTIONAL AND RESOURCE MATERIALS:
   • Cengage Learning
   • Student Data Files
10. METHODS OF ASSESSMENT:
    • Outcomes #1, 5, 6, and 9 will be assessed by the following:
      • Hands-on and written examinations
      • Hands-on tutorials and lab assignments
      • Development of portfolio project
11. ADA STATEMENT
    • If you believe that you are entitled to special accommodations under the Americans with Disabilities Act, please contact the Dean of Student Services at 620-417-1016 or visit the office located in the Hobble Academic Building.    
    
    Revised 07/14